


using System;
using SubSonic.Schema;
using System.Collections.Generic;
using SubSonic.DataProviders;
using System.Data;

namespace Food.Data {
	
        /// <summary>
        /// Table: episodes
        /// Primary Key: id
        /// </summary>

        public class episodesTable: DatabaseTable {
            
            public episodesTable(IDataProvider provider):base("episodes",provider){
                ClassName = "episode";
                SchemaName = "";
                

                Columns.Add(new DatabaseColumn("id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int64,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 8
                });

                Columns.Add(new DatabaseColumn("season", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int32,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 4
                });

                Columns.Add(new DatabaseColumn("name", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 2147483647
                });
                    
                
                
            }

            public IColumn id{
                get{
                    return this.GetColumn("id");
                }
            }
				
   			public static string idColumn{
			      get{
        			return "id";
      			}
		    }
            
            public IColumn season{
                get{
                    return this.GetColumn("season");
                }
            }
				
   			public static string seasonColumn{
			      get{
        			return "season";
      			}
		    }
            
            public IColumn name{
                get{
                    return this.GetColumn("name");
                }
            }
				
   			public static string nameColumn{
			      get{
        			return "name";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: foods
        /// Primary Key: id
        /// </summary>

        public class foodsTable: DatabaseTable {
            
            public foodsTable(IDataProvider provider):base("foods",provider){
                ClassName = "food";
                SchemaName = "";
                

                Columns.Add(new DatabaseColumn("id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int64,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 8
                });

                Columns.Add(new DatabaseColumn("type_id", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int64,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 8
                });

                Columns.Add(new DatabaseColumn("name", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 2147483647
                });
                    
                
                
            }

            public IColumn id{
                get{
                    return this.GetColumn("id");
                }
            }
				
   			public static string idColumn{
			      get{
        			return "id";
      			}
		    }
            
            public IColumn type_id{
                get{
                    return this.GetColumn("type_id");
                }
            }
				
   			public static string type_idColumn{
			      get{
        			return "type_id";
      			}
		    }
            
            public IColumn name{
                get{
                    return this.GetColumn("name");
                }
            }
				
   			public static string nameColumn{
			      get{
        			return "name";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: foods_episodes
        /// Primary Key: 
        /// </summary>

        public class foods_episodesTable: DatabaseTable {
            
            public foods_episodesTable(IDataProvider provider):base("foods_episodes",provider){
                ClassName = "foods_episode";
                SchemaName = "";
                

                Columns.Add(new DatabaseColumn("food_id", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int64,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 8
                });

                Columns.Add(new DatabaseColumn("episode_id", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.Int64,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 8
                });
                    
                
                
            }

            public IColumn food_id{
                get{
                    return this.GetColumn("food_id");
                }
            }
				
   			public static string food_idColumn{
			      get{
        			return "food_id";
      			}
		    }
            
            public IColumn episode_id{
                get{
                    return this.GetColumn("episode_id");
                }
            }
				
   			public static string episode_idColumn{
			      get{
        			return "episode_id";
      			}
		    }
            
                    
        }
        
        /// <summary>
        /// Table: food_types
        /// Primary Key: id
        /// </summary>

        public class food_typesTable: DatabaseTable {
            
            public food_typesTable(IDataProvider provider):base("food_types",provider){
                ClassName = "food_type";
                SchemaName = "";
                

                Columns.Add(new DatabaseColumn("id", this)
                {
	                IsPrimaryKey = true,
	                DataType = DbType.Int64,
	                IsNullable = false,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 8
                });

                Columns.Add(new DatabaseColumn("name", this)
                {
	                IsPrimaryKey = false,
	                DataType = DbType.AnsiString,
	                IsNullable = true,
	                AutoIncrement = false,
	                IsForeignKey = false,
	                MaxLength = 2147483647
                });
                    
                
                
            }

            public IColumn id{
                get{
                    return this.GetColumn("id");
                }
            }
				
   			public static string idColumn{
			      get{
        			return "id";
      			}
		    }
            
            public IColumn name{
                get{
                    return this.GetColumn("name");
                }
            }
				
   			public static string nameColumn{
			      get{
        			return "name";
      			}
		    }
            
                    
        }
        
}